Previous Topic

Next Topic

Create a SQL Table called OpportunityMainJob

You need to create a table that contains the fields you want to display in the opportunity. The following script creates a SQL table called OpportunityMainJob.

Note: The OpportunityKey field is required.

if exists (select * from dbo.sysobjects where id = 
object_id(N'[dbo].[OpportunityMainJob]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OpportunityMainJob]
GO
CREATE TABLE [dbo].[OpportunityMainJob] (
[OpportuityKey] [uniqueidentifier] NOT NULL,
[JobNumber] [int] NOT NULL)

See Also

Example: Building a new Opportunity business object

Add the OpportunityMainJob Table to the Opportunity Management Framework

Customize OpportunityJob Display Properties

Build a Relationship Between OpportunityJob and AccessMain

Modify the OpportunityType Business Object

Build and Publish the OpportunityJob Business Object

Create a New Opportunity Type for Opportunity Job


ASI logo 10.6 Production Release. Updated 7/20/2005 2:03:56 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.